[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS * ORDER BY OrderDate.YearMonth()Id DESC > TITLE Internet sales per year and month
39 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
2024-05 | 27.6K | 0 | 0 | 0 | 0 | 0 | 27.6K |
2024-04 | 1.0M | 236K | 61K | 0 | 0 | 138K | 572K |
2024-03 | 1.9M | 476K | 142K | 0 | 0 | 230K | 1.1M |
2024-02 | 1.7M | 444K | 124K | 0 | 0 | 205K | 947K |
2024-01 | 1.5M | 391K | 95K | 0 | 0 | 183K | 837K |
2023-12 | 1.5M | 412K | 88K | 0 | 0 | 192K | 826K |
2023-11 | 1.4M | 410K | 88K | 0 | 0 | 181K | 719K |
2023-10 | 1.5M | 381K | 140K | 0 | 0 | 190K | 808K |
2023-09 | 1.5M | 365K | 87K | 0 | 0 | 222K | 834K |
2023-08 | 1.1M | 350K | 66K | 0 | 0 | 141K | 539K |
2023-07 | 1.1M | 328K | 73K | 0 | 0 | 130K | 523K |
2023-06 | 953K | 246K | 60K | 0 | 0 | 131K | 517K |
2023-05 | 837K | 205K | 42.4K | 0 | 0 | 143K | 447K |
2023-04 | 699K | 230K | 26.2K | 0 | 0 | 86K | 357K |
2023-03 | 577K | 215K | 15.3K | 0 | 0 | 59K | 288K |
2023-02 | 477K | 184K | 20.5K | 0 | 0 | 55K | 217K |
2023-01 | 520K | 209K | 21.4K | 0 | 0 | 57K | 233K |
2022-12 | 509K | 216K | 20.8K | 0 | 0 | 64K | 207K |
2022-11 | 470K | 192K | 22.5K | 0 | 0 | 63K | 193K |
2022-10 | 512K | 206K | 21.2K | 0 | 0 | 69K | 216K |
2022-09 | 467K | 149K | 14.1K | 0 | 0 | 70K | 234K |
2022-08 | 378K | 137K | 15.4K | 0 | 0 | 43.0K | 182K |
2022-07 | 370K | 162K | 17.0K | 0 | 0 | 51K | 140K |
2022-06 | 462K | 140K | 18.8K | 0 | 0 | 66K | 238K |
2022-05 | 509K | 139K | 42.3K | 0 | 0 | 45.5K | 282K |
2022-04 | 613K | 155K | 65K | 0 | 0 | 39.6K | 354K |
2022-03 | 640K | 211K | 47.4K | 0 | 0 | 36.6K | 345K |
2022-02 | 650K | 224K | 46.3K | 0 | 0 | 28.7K | 351K |
2022-01 | 654K | 219K | 57K | 0 | 0 | 42.9K | 335K |
2021-12 | 598K | 212K | 42.7K | 0 | 0 | 18.0K | 325K |
2021-11 | 615K | 206K | 50K | 0 | 0 | 79K | 280K |
2021-10 | 660K | 222K | 51K | 29.4K | 18.6K | 61K | 278K |
2021-09 | 617K | 228K | 44.0K | 40.2K | 37.5K | 40.2K | 227K |
2021-08 | 546K | 232K | 9.3K | 52K | 25.5K | 31.2K | 196K |
2021-07 | 539K | 205K | 14.1K | 28.9K | 29.8K | 77K | 184K |
2021-06 | 470K | 183K | 28.9K | 33.6K | 21.8K | 61K | 141K |
2021-05 | 520K | 257K | 25.5K | 35.6K | 33.2K | 33.9K | 135K |
2021-04 | 199K | 75K | 3.6K | 17.9K | 14.1K | 22.7K | 66K |
_SUM | 29.4M | 9.1M | 1.8M | 238K | 181K | 3.4M | 14.7M |
Generated 2024-05-16 12:29:17.320 UTC